2014-06-09 - 13182 - Spec - OLAP Analysis query #BExQueriesforCrystalReportsAnalysisTool
SPECIFICATIONS
13182 - OLAP Analysis query
Requirement Summary
Create OLAP Analysis query off ZMP_OOCON Multiprovider.
Admin Info
Purpose
|
To Create OLAP Analysis BEx Query off ZMP_OOCON Multiprovider.
|
Requested By
|
Mark Harris
|
Spec Created By
|
Chandramouli K
|
Spec Created Date
|
06/10/2014
|
Spec QA by
|
Chandramouli K
|
Objects
|
VMP_OOCON_Q001
|
Document Status
|
Complete
|
References
Prior Tickets
None
Documents
Attached with related release note.
Functional Requirement
1. Need to Switch on Navigational Attributes 0MATERIAL_0AF_COLOR, 0MATERIAL_Z_PMSCOL in ZMP_OOCON Multiprovider.
2. Need to create BEx Query in BPD(BW 7.3 Development) system on ZMP_OOCON multiprovider same as VMP_OPASA_Q002 BEx Query.
Solution Summary
1. Need to Switch on Navigational Attributes in ZMP_OOCON Multiprovider.
2. Need to create a BEx Query in BPD(BW 7.3 Development).
3. Need to maintain required Characteristics, Key Figures and other query properties as per the NEC requirement.
4. Check the BEx query for QA STandards.
5. Test and transport it to BPQ.
Test Plan
SNo
|
Test Scenario
|
Expected Results
|
1
|
Check if navigational attributes are switched on in ZMP_OOCON Multiprovider..
|
0MATERIAL_0AF_COLOR and 0MATERIAL_Z_PMSCOL should be switched on as navigational attributes in ZMP_OOCON Multiprovider.
|
2.
|
Check the query against NEC Standard BEx checklist.
|
Query should pass all test cases as per checklist.
|
3.
|
Test the Query functionality in BPQ.
|
Query should be successfully vaildated in BPQ.
|
Solution Details
1. Need to Switch on Navigational Attributes 0MATERIAL_0AF_COLOR, 0MATERIAL_Z_PMSCOL in ZMP_OOCON Multiprovider.
2. Need to create a BEx Query in BPD(BW 7.3 Development) as per naming conventions.
3. Need to maintain required Characteristics, Key Figures and other query properties as per the NEC requirement.
4. Check the BEx query for QA Standards and data in BPQ system.
5. Unit Test the query and then transport it to BPQ for further testing.
Issues
None